Excel Level 2 (Intermediate)

Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel.

Lesson 1: Managing workbooks and worksheets
Viewing large worksheets
Printing large worksheets
Working with multiple worksheets
Linking worksheets with 3D formulas
Using multiple workbooks
Linking workbooks

Lesson 2: Advanced formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting

Lesson 3: Outlining and subtotals
Outlining and consolidating data
Creating subtotals

Lesson 4: Cell and range names
Creating and using names
Managing names

Lesson 5:Tables
Sorting and filtering data
Advanced filtering
Working with tables

Lesson 6: Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Sharing workbooks

Lesson 7: Documenting and auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration

Lesson 8:Templates and settings
Application settings
Built-in templates
Creating and managing templates

Printable course details

or equivalent knowledge.

7.5 hours

Individual Tuition

Group Training

Distance Learning

Prices

Distance Learning price